package com.bean;

import com.baomidou.mybatisplus.annotation.IdType;
import com.baomidou.mybatisplus.annotation.TableId;
import com.baomidou.mybatisplus.annotation.TableName;
import com.common.enumbean.Gender;
import lombok.Data;
import lombok.NoArgsConstructor;

import java.time.LocalDateTime;
@Data
@NoArgsConstructor()
@TableName("customers")
public class Customers extends BaseBean{
    //CREATE TABLE customers (
    //    id INT AUTO_INCREMENT PRIMARY KEY,
    //    name VARCHAR(150) NOT NULL,
    //    email VARCHAR(100) UNIQUE NOT NULL,
    //    phone CHAR(11),
    //    birthdate DATE,
    //    gender ENUM('男','女'),
    //    created_at DATETIME DEFAULT CURRENT_TIMESTAMP,
    //    updated_at DATETIME DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    //    INDEX name_idx (name),
    //    INDEX phone_idx(phone),
    //    INDEX order_idx (updated_at)
    //) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
    @TableId(type= IdType.AUTO)
    private Integer id;

    private String name;
    private String email;
    private String phone;
    private String birthdate;
    private Gender gender;


}
